<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<title>SsaDatabase xref</title>
<link type="text/css" rel="stylesheet" href="../../../../../stylesheet.css" />
</head>
<body>
<div id="overview"><a href="../../../../../../apidocs/org/inftel/ssa/mobile/provider/SsaDatabase.html">View Javadoc</a></div><pre>

<a class="jxr_linenumber" name="1" href="#1">1</a>   
<a class="jxr_linenumber" name="2" href="#2">2</a>   <strong class="jxr_keyword">package</strong> org.inftel.ssa.mobile.provider;
<a class="jxr_linenumber" name="3" href="#3">3</a>   
<a class="jxr_linenumber" name="4" href="#4">4</a>   <strong class="jxr_keyword">import</strong> org.inftel.ssa.mobile.provider.SsaContract.ProjectsColumns;
<a class="jxr_linenumber" name="5" href="#5">5</a>   <strong class="jxr_keyword">import</strong> org.inftel.ssa.mobile.provider.SsaContract.SprintsColumns;
<a class="jxr_linenumber" name="6" href="#6">6</a>   <strong class="jxr_keyword">import</strong> org.inftel.ssa.mobile.provider.SsaContract.SyncColumns;
<a class="jxr_linenumber" name="7" href="#7">7</a>   <strong class="jxr_keyword">import</strong> org.inftel.ssa.mobile.provider.SsaContract.TasksColumns;
<a class="jxr_linenumber" name="8" href="#8">8</a>   <strong class="jxr_keyword">import</strong> org.inftel.ssa.mobile.provider.SsaContract.UsersColumns;
<a class="jxr_linenumber" name="9" href="#9">9</a>   
<a class="jxr_linenumber" name="10" href="#10">10</a>  <strong class="jxr_keyword">import</strong> android.content.Context;
<a class="jxr_linenumber" name="11" href="#11">11</a>  <strong class="jxr_keyword">import</strong> android.database.sqlite.SQLiteDatabase;
<a class="jxr_linenumber" name="12" href="#12">12</a>  <strong class="jxr_keyword">import</strong> android.database.sqlite.SQLiteOpenHelper;
<a class="jxr_linenumber" name="13" href="#13">13</a>  <strong class="jxr_keyword">import</strong> android.provider.BaseColumns;
<a class="jxr_linenumber" name="14" href="#14">14</a>  <strong class="jxr_keyword">import</strong> android.util.Log;
<a class="jxr_linenumber" name="15" href="#15">15</a>  
<a class="jxr_linenumber" name="16" href="#16">16</a>  <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../org/inftel/ssa/mobile/provider/SsaDatabase.html">SsaDatabase</a> <strong class="jxr_keyword">extends</strong> SQLiteOpenHelper {
<a class="jxr_linenumber" name="17" href="#17">17</a>  
<a class="jxr_linenumber" name="18" href="#18">18</a>      <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String TAG = <span class="jxr_string">"SsaDatabase"</span>;
<a class="jxr_linenumber" name="19" href="#19">19</a>  
<a class="jxr_linenumber" name="20" href="#20">20</a>      <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String DATABASE_NAME = <span class="jxr_string">"ssa.db"</span>;
<a class="jxr_linenumber" name="21" href="#21">21</a>  
<a class="jxr_linenumber" name="22" href="#22">22</a>      <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">int</strong> DATABASE_VERSION = 1;
<a class="jxr_linenumber" name="23" href="#23">23</a>  
<a class="jxr_linenumber" name="24" href="#24">24</a>      <strong class="jxr_keyword">interface</strong> <a href="../../../../../org/inftel/ssa/mobile/provider/SsaDatabase.html">Tables</a> {
<a class="jxr_linenumber" name="25" href="#25">25</a>          String PROJECTS = <span class="jxr_string">"projects"</span>;
<a class="jxr_linenumber" name="26" href="#26">26</a>          String TASKS = <span class="jxr_string">"tasks"</span>;
<a class="jxr_linenumber" name="27" href="#27">27</a>          String SPRINTS = <span class="jxr_string">"sprints"</span>;
<a class="jxr_linenumber" name="28" href="#28">28</a>          String USERS = <span class="jxr_string">"users"</span>;
<a class="jxr_linenumber" name="29" href="#29">29</a>          String PROJECTS_USERS = <span class="jxr_string">"projects_users"</span>;
<a class="jxr_linenumber" name="30" href="#30">30</a>  
<a class="jxr_linenumber" name="31" href="#31">31</a>          String PROJECTS_USERS_JOIN_USERS = <span class="jxr_string">"projects_users "</span> +
<a class="jxr_linenumber" name="32" href="#32">32</a>                  <span class="jxr_string">"LEFT OUTER JOIN users ON projects_users.user_id=users._id"</span>;
<a class="jxr_linenumber" name="33" href="#33">33</a>      }
<a class="jxr_linenumber" name="34" href="#34">34</a>  
<a class="jxr_linenumber" name="35" href="#35">35</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">interface</strong> <a href="../../../../../org/inftel/ssa/mobile/provider/SsaDatabase.html">ProjectsUsers</a> {
<a class="jxr_linenumber" name="36" href="#36">36</a>          String PROJECT_ID = <span class="jxr_string">"project_id"</span>;
<a class="jxr_linenumber" name="37" href="#37">37</a>          String USER_ID = <span class="jxr_string">"user_id"</span>;
<a class="jxr_linenumber" name="38" href="#38">38</a>      }
<a class="jxr_linenumber" name="39" href="#39">39</a>  
<a class="jxr_linenumber" name="40" href="#40">40</a>      <strong class="jxr_keyword">public</strong> <a href="../../../../../org/inftel/ssa/mobile/provider/SsaDatabase.html">SsaDatabase</a>(Context context) {
<a class="jxr_linenumber" name="41" href="#41">41</a>          <strong class="jxr_keyword">super</strong>(context, DATABASE_NAME, <strong class="jxr_keyword">null</strong>, DATABASE_VERSION);
<a class="jxr_linenumber" name="42" href="#42">42</a>      }
<a class="jxr_linenumber" name="43" href="#43">43</a>  
<a class="jxr_linenumber" name="44" href="#44">44</a>      @Override
<a class="jxr_linenumber" name="45" href="#45">45</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> onCreate(SQLiteDatabase db) {
<a class="jxr_linenumber" name="46" href="#46">46</a>          db.execSQL(<span class="jxr_string">"CREATE TABLE "</span> + Tables.PROJECTS + <span class="jxr_string">" ("</span>
<a class="jxr_linenumber" name="47" href="#47">47</a>                  + BaseColumns._ID + <span class="jxr_string">" INTEGER PRIMARY KEY AUTOINCREMENT,"</span>
<a class="jxr_linenumber" name="48" href="#48">48</a>                  + ProjectsColumns.PROJECT_NAME + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="49" href="#49">49</a>                  + ProjectsColumns.PROJECT_SUMMARY + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="50" href="#50">50</a>                  + ProjectsColumns.PROJECT_DESCRIPTION + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="51" href="#51">51</a>                  + ProjectsColumns.PROJECT_OPENED + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="52" href="#52">52</a>                  + ProjectsColumns.PROJECT_STARTED + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="53" href="#53">53</a>                  + ProjectsColumns.PROJECT_CLOSE + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="54" href="#54">54</a>                  + ProjectsColumns.PROJECT_COMPANY + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="55" href="#55">55</a>                  + ProjectsColumns.PROJECT_LINKS + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="56" href="#56">56</a>                  + ProjectsColumns.PROJECT_LABELS + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="57" href="#57">57</a>                  + ProjectsColumns.PROJECT_LICENSE + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="58" href="#58">58</a>                  + SyncColumns.REMOTE_ID + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="59" href="#59">59</a>                  + SyncColumns.STABLE_ID + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="60" href="#60">60</a>                  + SyncColumns.SYNC_STATUS + <span class="jxr_string">" INTEGER)"</span>);
<a class="jxr_linenumber" name="61" href="#61">61</a>  
<a class="jxr_linenumber" name="62" href="#62">62</a>          db.execSQL(<span class="jxr_string">"CREATE TABLE "</span> + Tables.PROJECTS_USERS + <span class="jxr_string">" ("</span>
<a class="jxr_linenumber" name="63" href="#63">63</a>                  + BaseColumns._ID + <span class="jxr_string">" INTEGER PRIMARY KEY AUTOINCREMENT,"</span>
<a class="jxr_linenumber" name="64" href="#64">64</a>                  + ProjectsUsers.PROJECT_ID + <span class="jxr_string">" INTEGER NOT NULL,"</span>
<a class="jxr_linenumber" name="65" href="#65">65</a>                  + ProjectsUsers.USER_ID + <span class="jxr_string">" INTEGER NOT NULL,"</span>
<a class="jxr_linenumber" name="66" href="#66">66</a>                  + <span class="jxr_string">"UNIQUE ( "</span> + ProjectsUsers.PROJECT_ID + <span class="jxr_string">","</span> + ProjectsUsers.USER_ID + <span class="jxr_string">")"</span>
<a class="jxr_linenumber" name="67" href="#67">67</a>                  + <span class="jxr_string">" ON CONFLICT REPLACE)"</span>);
<a class="jxr_linenumber" name="68" href="#68">68</a>  
<a class="jxr_linenumber" name="69" href="#69">69</a>          db.execSQL(<span class="jxr_string">"CREATE TABLE "</span> + Tables.TASKS + <span class="jxr_string">" ("</span>
<a class="jxr_linenumber" name="70" href="#70">70</a>                  + BaseColumns._ID + <span class="jxr_string">" INTEGER PRIMARY KEY AUTOINCREMENT,"</span>
<a class="jxr_linenumber" name="71" href="#71">71</a>                  + TasksColumns.TASK_DESCRIPTION + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="72" href="#72">72</a>                  + TasksColumns.TASK_SUMMARY + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="73" href="#73">73</a>                  + TasksColumns.TASK_ESTIMATED + <span class="jxr_string">" INTEGER,"</span>
<a class="jxr_linenumber" name="74" href="#74">74</a>                  + TasksColumns.TASK_BURNED + <span class="jxr_string">" INTEGER,"</span>
<a class="jxr_linenumber" name="75" href="#75">75</a>                  + TasksColumns.TASK_REMAINING + <span class="jxr_string">" INTEGER,"</span>
<a class="jxr_linenumber" name="76" href="#76">76</a>                  + TasksColumns.TASK_PRIORITY + <span class="jxr_string">" INTEGER,"</span>
<a class="jxr_linenumber" name="77" href="#77">77</a>                  + TasksColumns.TASK_BEGINDATE + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="78" href="#78">78</a>                  + TasksColumns.TASK_ENDDATE + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="79" href="#79">79</a>                  + TasksColumns.TASK_STATUS + <span class="jxr_string">" INTEGER,"</span>
<a class="jxr_linenumber" name="80" href="#80">80</a>                  + TasksColumns.TASK_CREATED + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="81" href="#81">81</a>                  + TasksColumns.TASK_COMMENTS + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="82" href="#82">82</a>                  + TasksColumns.TASK_SPRINT_ID + <span class="jxr_string">" INTEGER,"</span>
<a class="jxr_linenumber" name="83" href="#83">83</a>                  + TasksColumns.TASK_PROJECT_ID + <span class="jxr_string">" INTEGER,"</span>
<a class="jxr_linenumber" name="84" href="#84">84</a>                  + TasksColumns.TASK_USER_ID + <span class="jxr_string">" INTEGER,"</span>
<a class="jxr_linenumber" name="85" href="#85">85</a>                  + SyncColumns.REMOTE_ID + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="86" href="#86">86</a>                  + SyncColumns.STABLE_ID + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="87" href="#87">87</a>                  + SyncColumns.SYNC_STATUS + <span class="jxr_string">" INTEGER)"</span>);
<a class="jxr_linenumber" name="88" href="#88">88</a>  
<a class="jxr_linenumber" name="89" href="#89">89</a>          db.execSQL(<span class="jxr_string">"CREATE TABLE "</span> + Tables.SPRINTS + <span class="jxr_string">" ("</span>
<a class="jxr_linenumber" name="90" href="#90">90</a>                  + BaseColumns._ID + <span class="jxr_string">" INTEGER PRIMARY KEY AUTOINCREMENT,"</span>
<a class="jxr_linenumber" name="91" href="#91">91</a>                  + SprintsColumns.SPRINT_SUMMARY + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="92" href="#92">92</a>                  + SprintsColumns.SPRINT_PROJECT_ID + <span class="jxr_string">" INTEGER,"</span>
<a class="jxr_linenumber" name="93" href="#93">93</a>                  + SyncColumns.REMOTE_ID + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="94" href="#94">94</a>                  + SyncColumns.STABLE_ID + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="95" href="#95">95</a>                  + SyncColumns.SYNC_STATUS + <span class="jxr_string">" INTEGER)"</span>);
<a class="jxr_linenumber" name="96" href="#96">96</a>  
<a class="jxr_linenumber" name="97" href="#97">97</a>          db.execSQL(<span class="jxr_string">"CREATE TABLE "</span> + Tables.USERS + <span class="jxr_string">" ("</span>
<a class="jxr_linenumber" name="98" href="#98">98</a>                  + BaseColumns._ID + <span class="jxr_string">"  INTEGER PRIMARY KEY AUTOINCREMENT,"</span>
<a class="jxr_linenumber" name="99" href="#99">99</a>                  + UsersColumns.USER_FULLNAME + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="100" href="#100">100</a>                 + UsersColumns.USER_NICKNAME + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="101" href="#101">101</a>                 + UsersColumns.USER_EMAIL + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="102" href="#102">102</a>                 + UsersColumns.USER_NUMBER + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="103" href="#103">103</a>                 + UsersColumns.USER_COMPANY + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="104" href="#104">104</a>                 + UsersColumns.USER_PASS + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="105" href="#105">105</a>                 + UsersColumns.USER_ROLE + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="106" href="#106">106</a>                 + SyncColumns.REMOTE_ID + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="107" href="#107">107</a>                 + SyncColumns.STABLE_ID + <span class="jxr_string">" TEXT,"</span>
<a class="jxr_linenumber" name="108" href="#108">108</a>                 + SyncColumns.SYNC_STATUS + <span class="jxr_string">" INTEGER)"</span>);
<a class="jxr_linenumber" name="109" href="#109">109</a>     }
<a class="jxr_linenumber" name="110" href="#110">110</a> 
<a class="jxr_linenumber" name="111" href="#111">111</a>     @Override
<a class="jxr_linenumber" name="112" href="#112">112</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> onUpgrade(SQLiteDatabase db, <strong class="jxr_keyword">int</strong> oldVersion, <strong class="jxr_keyword">int</strong> newVersion) {
<a class="jxr_linenumber" name="113" href="#113">113</a>         Log.w(TAG, <span class="jxr_string">"Destroying old data during upgrade"</span>);
<a class="jxr_linenumber" name="114" href="#114">114</a>         db.execSQL(<span class="jxr_string">"DROP TABLE IF EXISTS "</span> + Tables.PROJECTS);
<a class="jxr_linenumber" name="115" href="#115">115</a>         db.execSQL(<span class="jxr_string">"DROP TABLE IF EXISTS "</span> + Tables.PROJECTS_USERS);
<a class="jxr_linenumber" name="116" href="#116">116</a>         db.execSQL(<span class="jxr_string">"DROP TABLE IF EXISTS "</span> + Tables.TASKS);
<a class="jxr_linenumber" name="117" href="#117">117</a>         db.execSQL(<span class="jxr_string">"DROP TABLE IF EXISTS "</span> + Tables.SPRINTS);
<a class="jxr_linenumber" name="118" href="#118">118</a>         db.execSQL(<span class="jxr_string">"DROP TABLE IF EXISTS "</span> + Tables.USERS);
<a class="jxr_linenumber" name="119" href="#119">119</a>     }
<a class="jxr_linenumber" name="120" href="#120">120</a> }
</pre>
<hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
</html>

